use master
go

create database Mock
go
use Mock
go

create table Programme
(
	ProgrammeID int primary key identity,
	ProgrammeName nvarchar(222),
	Description nvarchar(222),
	IsActive nvarchar(10),
	ContactID int references Contact(ContactID)
)

create table Contact
(
	ContactID int primary key identity,
	ContactNumber int,
	contactName nvarchar(222)
)
insert into Contact values(1111,'bbb')
insert into Contact values(222,'ccc')
insert into Contact values(112211,'eee')
insert into Contact values(222211,'ddd')

insert into Programme values('aaa','eee','yes',1)
insert into Programme values('bbb','aaa','yes',1)
insert into Programme values('ccc','ccc','no',2)
insert into Programme values('ddd','mmm','no',3)
insert into Programme values('viet','vn','no',2)

select * from Programme